@REM Please install  webdeployment tool first,  http://www.iis.net/expand/WebDeploymentTool 
@REM Usage: SetupFullDB DB connection string, such as:
@REM 	SetupFullDB.cmd "Server=tcp:SQLAZUREDBNAME.database.windows.net;Database=LocationsDB;User ID=USERNAME;Password=PASSSWORD;Trusted_Connection=False;Encrypt=True;"
@REM 	SetupFullDB.cmd "Data Source=.\SQLEXPRESS;AttachDbFilename=F:\Microsoft\public\OlympicApp\MapWayCodePlex\WebRole1\App_Data\LocationsDB.mdf;Integrated Security=True;User Instance=True;"

"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\DataInstall.sql" -dest:dbfullsql=%1

"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city1.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city2.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city3.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city4.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city5.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city6.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city7.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city8.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city9.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city10.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city11.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city12.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city13.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city14.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city15.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city16.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city17.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city18.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city19.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city20.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city21.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city22.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city23.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city24.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city25.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city26.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city27.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city28.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city29.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city30.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city31.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city32.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city33.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city34.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city35.sql" -dest:dbfullsql=%1,transacted=false
"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\city36.sql" -dest:dbfullsql=%1,transacted=false

"c:\Program Files\IIS\Microsoft Web Deploy\msdeploy.exe" -verb:sync -source:dbfullsql="%cd%\DataInstall2.sql" -dest:dbfullsql=%1
